Error: #NULL! displays due to space used to separate cell references.
Error:
#NULL!
Cause:
A space instead of a comma has been entered to separate cell references that are arguments for functions.
Solution:
Type the correct range operator (comma) between ranges in the formula.
NOTE: NO spaces are accepted in formulas.